<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.17"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>Aestate: aestate/work/orm.py Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">Aestate
   &#160;<span id="projectnumber">1.0.5</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.17 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="dir_374ee6e3281d8312d956f1f155302869.html">aestate</a></li><li class="navelem"><a class="el" href="dir_5abfa80149f37441c1f61fb6211d8f7d.html">work</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="headertitle">
<div class="title">orm.py</div>  </div>
</div><!--header-->
<div class="contents">
<a href="orm_8py.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"><a class="line" href="namespaceaestate_1_1work_1_1orm.html">    1</a></span>&#160;<span class="keyword">from</span> enum <span class="keyword">import</span> Enum</div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="keyword">from</span> typing <span class="keyword">import</span> List</div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160; </div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1exception.html">aestate.exception</a> <span class="keyword">import</span> SqlResultError</div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1util_1_1_log.html">aestate.util.Log</a> <span class="keyword">import</span> ALog</div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="keyword">from</span> prettytable <span class="keyword">import</span> PrettyTable</div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160; </div>
<div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1work_1_1_serialize.html">aestate.work.Serialize</a> <span class="keyword">import</span> QuerySet</div>
<div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160; </div>
<div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160; </div>
<div class="line"><a name="l00011"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_base_cover.html">   11</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_base_cover.html">BaseCover</a>:</div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160; </div>
<div class="line"><a name="l00013"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#a670815366267017770d6db1ada6ac5b2">   13</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#a670815366267017770d6db1ada6ac5b2">table_visual</a>(self, title: list, val: List[dict]) -&gt; PrettyTable:</div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;        <span class="keywordflow">if</span> <span class="keywordflow">not</span> val:</div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;            ALog.log_error(</div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;                msg=<span class="stringliteral">&#39;The database gets no return from the SQL of the field type in the table,&#39;</span></div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;                    <span class="stringliteral">&#39; and the SQL is written incorrectly, please check the SQL&#39;</span>,</div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;                obj=SqlResultError, raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160; </div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;        table = PrettyTable(title)</div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;        table.border = <span class="keyword">True</span></div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;        [table.add_row(list(i.values())) <span class="keywordflow">for</span> i <span class="keywordflow">in</span> val]</div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;        <span class="keywordflow">return</span> table</div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160; </div>
<div class="line"><a name="l00025"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#a5ea8415f62dd65c49595a0908378dc5d">   25</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#a5ea8415f62dd65c49595a0908378dc5d">check</a>(self, res, fields) -&gt; bool:</div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="stringliteral">        检查表与数据库中的数据是否对应</span></div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;        comment = {</div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;            <span class="stringliteral">&#39;auto_increment&#39;</span>: <span class="stringliteral">&quot;自增&quot;</span>,</div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;            <span class="stringliteral">&#39;DEFAULT_GENERATED&#39;</span>: <span class="stringliteral">&quot;自动追加日期&quot;</span>,</div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;            <span class="stringliteral">&#39;DEFAULT_GENERATED on update CURRENT_TIMESTAMP&#39;</span>: <span class="stringliteral">&quot;自动更新时间为最后一次更改时间&quot;</span></div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;        }</div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">False</span></div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160; </div>
<div class="line"><a name="l00036"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#af6f5380092b58753896534d43e9a7c77">   36</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#af6f5380092b58753896534d43e9a7c77">deal</a>(self, res, fields):</div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;<span class="stringliteral">        同步数据库与pojo的字段配置项</span></div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">True</span></div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160; </div>
<div class="line"><a name="l00042"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#ac402c2f8b3349e9150aad473020136e3">   42</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_base_cover.html#ac402c2f8b3349e9150aad473020136e3">res</a>(self, tb_name, db_name, extool) -&gt; dict:</div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;<span class="stringliteral">        获得表结构</span></div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;        sql = <span class="stringliteral">&quot;&quot;&quot;SELECT </span></div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;<span class="stringliteral">        COLUMN_NAME AS name, -- 名称</span></div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;<span class="stringliteral">        DATA_TYPE AS typer, -- 类型</span></div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;<span class="stringliteral">        CHARACTER_MAXIMUM_LENGTH AS length, -- 长度</span></div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;<span class="stringliteral">        NUMERIC_SCALE AS num_scale, -- 数字小数点</span></div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;<span class="stringliteral">        IS_NULLABLE AS is_null, -- 是否允许为空</span></div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;<span class="stringliteral">        COLUMN_KEY AS c_key, -- 是否为键</span></div>
<div class="line"><a name="l00053"></a><span class="lineno">   53</span>&#160;<span class="stringliteral">        EXTRA as def_val, -- 默认值</span></div>
<div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;<span class="stringliteral">        COLUMN_COMMENT as comment -- 描述</span></div>
<div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;<span class="stringliteral">        FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = %s AND TABLE_NAME = %s&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;        <span class="comment"># 使用传入的sql执行器执行查询表结构的sql</span></div>
<div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;        res = extool.select(sql=sql, params=[db_name, tb_name])</div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;        <span class="comment"># 获得表结构可视化</span></div>
<div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;        <span class="comment"># table = self.table_visual(list(res[0].keys()), res)</span></div>
<div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;        <span class="comment"># print(table)</span></div>
<div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160; </div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;        <span class="comment"># 对比结构</span></div>
<div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160; </div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;        <span class="keywordflow">return</span> res</div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160; </div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160; </div>
<div class="line"><a name="l00067"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html">   67</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html">AOrm</a>(object):</div>
<div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;<span class="stringliteral">    纯净的ORM模式:</span></div>
<div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;<span class="stringliteral">        你可以使用find(&#39;table&#39;).by(&#39;args&#39;).order_by(&#39;args&#39;).desc().end()方式执行sql</span></div>
<div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;<span class="stringliteral">        好处就是:</span></div>
<div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;<span class="stringliteral">            能更好的拒绝sql注入</span></div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;<span class="stringliteral">            无需写sql语句</span></div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;<span class="stringliteral">            代码简单易懂</span></div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;<span class="stringliteral">            上手快</span></div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;<span class="stringliteral">    &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160; </div>
<div class="line"><a name="l00078"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm_1_1_mode.html">   78</a></span>&#160;    <span class="keyword">class </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm_1_1_mode.html">Mode</a>(Enum):</div>
<div class="line"><a name="l00079"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm_1_1_mode.html#a6e23e2c2e63345e156b524e678e3b6a8">   79</a></span>&#160;        FIND = 0</div>
<div class="line"><a name="l00080"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm_1_1_mode.html#a97803a0394600fd3ba5994d9f917842e">   80</a></span>&#160;        INSERT = 1</div>
<div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160; </div>
<div class="line"><a name="l00082"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a13f5cec1d673aeaf79a374f966dd582d">   82</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a13f5cec1d673aeaf79a374f966dd582d">__init__</a>(self, repository):</div>
<div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;<span class="stringliteral">        初始化ORM</span></div>
<div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;<span class="stringliteral">        自定义方言除了可使用默认已存在的方法，还可以使用自定义sql方言拼接</span></div>
<div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;<span class="stringliteral">        :param repository:仓库</span></div>
<div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;<span class="stringliteral">s        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00091"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a3cb975fab2652904b97d5273879fdd24">   91</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a3cb975fab2652904b97d5273879fdd24">exmode</a> = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00092"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">   92</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a> = []</div>
<div class="line"><a name="l00093"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">   93</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">params</a> = []</div>
<div class="line"><a name="l00094"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">   94</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a> = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;        <span class="comment"># self.sqlFields = sqlFields</span></div>
<div class="line"><a name="l00096"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">   96</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a> = repository.config_obj</div>
<div class="line"><a name="l00097"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7716439abad4da73688382cf3b3ca1e9">   97</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7716439abad4da73688382cf3b3ca1e9">serializer</a> = repository.serializer</div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a> = repository.sqlFields</div>
<div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;        <span class="comment"># 创建sql语法</span></div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;        <span class="keywordflow">if</span> repository <span class="keywordflow">is</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;            ALog.log_error(</div>
<div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;                msg=<span class="stringliteral">&#39;Repository is null,Place use repository of ORM framework&#39;</span>,</div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;                obj=AttributeError, LogObject=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.log_obj, raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00104"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">  104</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a> = repository</div>
<div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;        <span class="comment"># self.__table_name__ = &#39;{}{}{}&#39;.format(self.sqlFields.left_subscript, repository.__table_name__,</span></div>
<div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;        <span class="comment">#                                       self.sqlFields.right_subscript)</span></div>
<div class="line"><a name="l00107"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7ab8434322f16348ffeab31e8d49a24c">  107</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7ab8434322f16348ffeab31e8d49a24c">__table_name__</a> = repository.__table_name__</div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160; </div>
<div class="line"><a name="l00109"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a20a40eeded43e60f93bf7904d81f9c24">  109</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a20a40eeded43e60f93bf7904d81f9c24">first_data</a> = <span class="keyword">False</span></div>
<div class="line"><a name="l00110"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">  110</a></span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a> = []</div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160; </div>
<div class="line"><a name="l00112"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aba9039f7e0b2d296188f876e9a7b698d">  112</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aba9039f7e0b2d296188f876e9a7b698d">top</a>(self):</div>
<div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a9fb4513ed4e7ca1470526c7faea7b841">find</a>()</div>
<div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a20a40eeded43e60f93bf7904d81f9c24">first_data</a> = <span class="keyword">True</span></div>
<div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7234a2fefab09fac24d58a77b2001bb2">limit</a>(1)</div>
<div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160; </div>
<div class="line"><a name="l00117"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a64abf4fbb49d50cc108f0c744594f042">  117</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a64abf4fbb49d50cc108f0c744594f042">first</a>(self):</div>
<div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;<span class="stringliteral">        是否只返回第一行数据</span></div>
<div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a20a40eeded43e60f93bf7904d81f9c24">first_data</a> = <span class="keyword">True</span></div>
<div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160; </div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;    <span class="comment"># ------------------------主键--------------------------</span></div>
<div class="line"><a name="l00125"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a9fb4513ed4e7ca1470526c7faea7b841">  125</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a9fb4513ed4e7ca1470526c7faea7b841">find</a>(self, *args, **kwargs):</div>
<div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;<span class="stringliteral">        查</span></div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;<span class="stringliteral">            find(&#39;all&#39;)</span></div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;<span class="stringliteral">            find(&#39;param1&#39;,asses=[&#39;p&#39;],h_func=True)</span></div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;<span class="stringliteral">        Attributes:</span></div>
<div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;<span class="stringliteral">            asses:将对应的字段转成另一个别名,不需要转换的使用None标识</span></div>
<div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;<span class="stringliteral">            h_func:不将字段转换成 `%s` 格式</span></div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;<span class="stringliteral">        更新:</span></div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;<span class="stringliteral">            如果args字段长度为0,默认为查找全部</span></div>
<div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a3cb975fab2652904b97d5273879fdd24">exmode</a> = AOrm.Mode.FIND</div>
<div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.find_str)</div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;        <span class="comment"># 如果有as字段</span></div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;        alias = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;        <span class="keywordflow">if</span> <span class="stringliteral">&#39;alias&#39;</span> <span class="keywordflow">in</span> kwargs.keys():</div>
<div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;            alias = kwargs[<span class="stringliteral">&#39;alias&#39;</span>]</div>
<div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;        <span class="comment"># 如果包含方法的字段，则不加密</span></div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;        func_flag = <span class="keyword">False</span></div>
<div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;        <span class="keywordflow">if</span> <span class="stringliteral">&#39;h_func&#39;</span> <span class="keywordflow">in</span> kwargs.keys():</div>
<div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;            func_flag = kwargs[<span class="stringliteral">&#39;h_func&#39;</span>]</div>
<div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;        <span class="comment"># 1.1.0.05更新,默认为all</span></div>
<div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;        _all = <span class="keyword">False</span></div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;        <span class="keywordflow">if</span> len(args) == 0:</div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;            _all = <span class="keyword">True</span></div>
<div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;        <span class="comment"># 如果存在all</span></div>
<div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;        <span class="comment"># 1.1.1.2修复：tuple index out of range</span></div>
<div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;        <span class="keywordflow">if</span> _all <span class="keywordflow">or</span> <span class="stringliteral">&#39;all&#39;</span>.upper() == args[0].upper():</div>
<div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;            <span class="comment"># 如果包含all关键字,则使用解析工具解析成字段参数</span></div>
<div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;            <span class="keywordflow">if</span> <span class="keywordflow">not</span> func_flag:</div>
<div class="line"><a name="l00156"></a><span class="lineno">  156</span>&#160;                fields = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.parse_key(</div>
<div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;                    *self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.fields, is_field=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;                fields = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.parse_key(</div>
<div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;                    *self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.fields, is_field=<span class="keyword">False</span>)</div>
<div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160;            <span class="keywordflow">if</span> <span class="keywordflow">not</span> func_flag:</div>
<div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;                fields = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.parse_key(*args, is_field=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;                fields = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.parse_key(*args, is_field=<span class="keyword">False</span>)</div>
<div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;        <span class="comment"># 解决as问题</span></div>
<div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160;        <span class="keywordflow">if</span> alias <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160;            fs = fields.split(<span class="stringliteral">&#39;,&#39;</span>)</div>
<div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;            <span class="keywordflow">if</span> len(fs) != len(alias):</div>
<div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;                <span class="comment"># 匿名参数长度与字段长度不符合</span></div>
<div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;                ALog.log_error(obj=TypeError,</div>
<div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;                               msg=<span class="stringliteral">&#39;The length of the anonymous parameter does not match the length of the field&#39;</span>,</div>
<div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;                               raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;            <span class="keywordflow">for</span> i, v <span class="keywordflow">in</span> enumerate(fs):</div>
<div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;                <span class="keywordflow">if</span> alias[i] <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;                    self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(<span class="stringliteral">&#39;{}{}{}&#39;</span>.format(</div>
<div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;                        v, self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.asses_str, alias[i]))</div>
<div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;                <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;                    self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(v)</div>
<div class="line"><a name="l00180"></a><span class="lineno">  180</span>&#160;                <span class="comment"># 逗号</span></div>
<div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.comma)</div>
<div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(fields)</div>
<div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;        <span class="keywordflow">if</span> alias <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;            <span class="comment"># 去掉末尾的逗号</span></div>
<div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aa02ed1b6ea243140a96615bce48b9c62">rep_sym</a>()</div>
<div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;        <span class="comment">#     加上from关键字</span></div>
<div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;        <span class="keywordflow">if</span> <span class="stringliteral">&#39;poly&#39;</span> <span class="keywordflow">not</span> <span class="keywordflow">in</span> kwargs.keys():</div>
<div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a562a70aa148e2a09e5075a22fa8d4328">con_from</a>()</div>
<div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a> += kwargs[<span class="stringliteral">&#39;poly&#39;</span>]</div>
<div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160; </div>
<div class="line"><a name="l00194"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2c4d974e8913c2a29f0dcdff18a88b85">  194</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2c4d974e8913c2a29f0dcdff18a88b85">order_by</a>(self, *args, **kwargs):</div>
<div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160;<span class="stringliteral">        根据什么查</span></div>
<div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).order_by(&#39;param&#39;)</span></div>
<div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).order_by(&#39;param&#39;).end()</span></div>
<div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).order_by(&#39;p1&#39;,&#39;p2&#39;).desc().limit(10,20)</span></div>
<div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad37f44b2337c88899e81367328a44777">by_opera</a>(field=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.order_by_str, args_list=args, **kwargs)</div>
<div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160; </div>
<div class="line"><a name="l00204"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a0dbc81a347ac1b5d2593c8e177a30efc">  204</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a0dbc81a347ac1b5d2593c8e177a30efc">group_by</a>(self, *args, **kwargs):</div>
<div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;<span class="stringliteral">        聚合函数</span></div>
<div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;<span class="stringliteral">            select shop_id,count(*) as count from comments group by shop_id having count&gt;1;</span></div>
<div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad37f44b2337c88899e81367328a44777">by_opera</a>(field=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.group_by_str, args_list=args, **kwargs)</div>
<div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160; </div>
<div class="line"><a name="l00212"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad37f44b2337c88899e81367328a44777">  212</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad37f44b2337c88899e81367328a44777">by_opera</a>(self, field, args_list, **kwargs):</div>
<div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;<span class="stringliteral">        根据什么查</span></div>
<div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(field)</div>
<div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;        <span class="keywordflow">for</span> i <span class="keywordflow">in</span> args_list:</div>
<div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;            <span class="keywordflow">if</span> <span class="keywordflow">not</span> kwargs.get(<span class="stringliteral">&#39;text&#39;</span>, <span class="keyword">False</span>):</div>
<div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.left_subscript)</div>
<div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(i)</div>
<div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;            <span class="keywordflow">if</span> <span class="keywordflow">not</span> kwargs.get(<span class="stringliteral">&#39;text&#39;</span>, <span class="keyword">False</span>):</div>
<div class="line"><a name="l00222"></a><span class="lineno">  222</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.right_subscript)</div>
<div class="line"><a name="l00223"></a><span class="lineno">  223</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.comma)</div>
<div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aa02ed1b6ea243140a96615bce48b9c62">rep_sym</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.comma, self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space)</div>
<div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160; </div>
<div class="line"><a name="l00227"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aecea12850afc3b40f8847c4b308978cb">  227</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aecea12850afc3b40f8847c4b308978cb">filter</a>(self, **kwargs):</div>
<div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a9fb4513ed4e7ca1470526c7faea7b841">find</a>().<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab2cbe9f088da506d307540e83e2fa784">where</a>(**kwargs).<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2134504d320f5a399f8b2341515093b6">end</a>()</div>
<div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160; </div>
<div class="line"><a name="l00230"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab2cbe9f088da506d307540e83e2fa784">  230</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab2cbe9f088da506d307540e83e2fa784">where</a>(self, **kwargs):</div>
<div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00232"></a><span class="lineno">  232</span>&#160;<span class="stringliteral">        当....</span></div>
<div class="line"><a name="l00233"></a><span class="lineno">  233</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00234"></a><span class="lineno">  234</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;%s&#39;) - 默认符号为等于 ==</span></div>
<div class="line"><a name="l00235"></a><span class="lineno">  235</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;==%s&#39;)</span></div>
<div class="line"><a name="l00236"></a><span class="lineno">  236</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;&gt;%d&#39;)</span></div>
<div class="line"><a name="l00237"></a><span class="lineno">  237</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;&lt;%d&#39;)</span></div>
<div class="line"><a name="l00238"></a><span class="lineno">  238</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;&lt;=%d&#39;)</span></div>
<div class="line"><a name="l00239"></a><span class="lineno">  239</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;&gt;=%.2f&#39;)</span></div>
<div class="line"><a name="l00240"></a><span class="lineno">  240</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;!=%.2f&#39;)</span></div>
<div class="line"><a name="l00241"></a><span class="lineno">  241</span>&#160;<span class="stringliteral">        复杂语法:</span></div>
<div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;+%d/%d==%d&#39;)</span></div>
<div class="line"><a name="l00243"></a><span class="lineno">  243</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;-%.2f*%d==12&#39;)</span></div>
<div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;*10-1==12&#39;)</span></div>
<div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;<span class="stringliteral">            find(&#39;ALL&#39;).where(param=&#39;/10+1==12&#39;)</span></div>
<div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.where_str)</div>
<div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;        <span class="keywordflow">for</span> key, value <span class="keywordflow">in</span> kwargs.items():</div>
<div class="line"><a name="l00249"></a><span class="lineno">  249</span>&#160;            cp_key = key</div>
<div class="line"><a name="l00250"></a><span class="lineno">  250</span>&#160;            customize = <span class="keyword">False</span></div>
<div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;            sym = <span class="stringliteral">&#39;=&#39;</span></div>
<div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160; </div>
<div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;            sps = cp_key.split(<span class="stringliteral">&#39;__&#39;</span>)</div>
<div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160; </div>
<div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;            <span class="keywordflow">if</span> len(str(value)) &gt; 2 <span class="keywordflow">and</span> str(value)[0:2] <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.symbol:</div>
<div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;                sym = value[0:2]</div>
<div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;                value = str(value)[2:len(str(value))]</div>
<div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;                <span class="keywordflow">if</span> sym == <span class="stringliteral">&#39;==&#39;</span>:</div>
<div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;                    sym = <span class="stringliteral">&#39;=&#39;</span></div>
<div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;                <span class="keywordflow">elif</span> sym == <span class="stringliteral">&#39;&gt;&gt;&#39;</span>:</div>
<div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;                    sym = <span class="stringliteral">&#39;&gt;&#39;</span></div>
<div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;                <span class="keywordflow">elif</span> sym == <span class="stringliteral">&#39;&lt;&lt;&#39;</span>:</div>
<div class="line"><a name="l00263"></a><span class="lineno">  263</span>&#160;                    sym = <span class="stringliteral">&#39;&lt;&#39;</span></div>
<div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;                <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;                    <span class="comment"># 没有找到符号的话就从字段名开始</span></div>
<div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;                    <span class="comment"># 截取最后一段从两段下划线开始的末尾</span></div>
<div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;                    <span class="keywordflow">if</span> <span class="keywordflow">not</span> len(sps) == 1:</div>
<div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;                        customize = <span class="keyword">True</span></div>
<div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160;                        sym = sps[len(sps) - 1]</div>
<div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;                        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.fieldExist(</div>
<div class="line"><a name="l00271"></a><span class="lineno">  271</span>&#160;                            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>, <span class="stringliteral">&#39;adapter&#39;</span>, raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;                        cp_key = cp_key[:cp_key.rfind(<span class="stringliteral">&#39;__&#39;</span> + sym)]</div>
<div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;                        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.adapter.funcs[sym](self, cp_key, value)</div>
<div class="line"><a name="l00274"></a><span class="lineno">  274</span>&#160; </div>
<div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160;            <span class="keywordflow">elif</span> <span class="keywordflow">not</span> len(sps) == 1:</div>
<div class="line"><a name="l00276"></a><span class="lineno">  276</span>&#160;                customize = <span class="keyword">True</span></div>
<div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;                sym = sps[len(sps) - 1]</div>
<div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.fieldExist(</div>
<div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;                    self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>, <span class="stringliteral">&#39;adapter&#39;</span>, raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;                cp_key = cp_key[:cp_key.rfind(<span class="stringliteral">&#39;__&#39;</span> + sym)]</div>
<div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.adapter.funcs[sym](self, cp_key, value)</div>
<div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160; </div>
<div class="line"><a name="l00283"></a><span class="lineno">  283</span>&#160;            <span class="keywordflow">if</span> <span class="keywordflow">not</span> customize:</div>
<div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(</div>
<div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;                    <span class="stringliteral">&#39;{}{}{}{}%s&#39;</span>.format(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.left_subscript,</div>
<div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;                                        cp_key,</div>
<div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;                                        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.right_subscript,</div>
<div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;                                        sym))</div>
<div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.ander_str)</div>
<div class="line"><a name="l00290"></a><span class="lineno">  290</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">params</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(value)</div>
<div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aa02ed1b6ea243140a96615bce48b9c62">rep_sym</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.ander_str)</div>
<div class="line"><a name="l00292"></a><span class="lineno">  292</span>&#160; </div>
<div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160; </div>
<div class="line"><a name="l00295"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a48d6b59a96a8ac8e9e19b6a5f4d80bf0">  295</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a48d6b59a96a8ac8e9e19b6a5f4d80bf0">on</a>(self, from_where, to_where, symbol=&#39;=&#39;):</div>
<div class="line"><a name="l00296"></a><span class="lineno">  296</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space)</div>
<div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.on_str)</div>
<div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space)</div>
<div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(from_where)</div>
<div class="line"><a name="l00300"></a><span class="lineno">  300</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space)</div>
<div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(symbol)</div>
<div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space)</div>
<div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(to_where)</div>
<div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00305"></a><span class="lineno">  305</span>&#160; </div>
<div class="line"><a name="l00306"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7234a2fefab09fac24d58a77b2001bb2">  306</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7234a2fefab09fac24d58a77b2001bb2">limit</a>(self, start=0, end=None):</div>
<div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160;<span class="stringliteral">        分页</span></div>
<div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;<span class="stringliteral">        :param start:开始</span></div>
<div class="line"><a name="l00310"></a><span class="lineno">  310</span>&#160;<span class="stringliteral">        :param end:末尾</span></div>
<div class="line"><a name="l00311"></a><span class="lineno">  311</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).limit(start=10,end=20)</span></div>
<div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).limit(end=10)</span></div>
<div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00315"></a><span class="lineno">  315</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.limit_str)</div>
<div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;        <span class="comment"># 死亡空格</span></div>
<div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;        <span class="keywordflow">if</span> end <span class="keywordflow">is</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;            limit_param = <span class="stringliteral">&#39;{}{}{}&#39;</span>.format(</div>
<div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space, start, self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space)</div>
<div class="line"><a name="l00320"></a><span class="lineno">  320</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;            limit_param = <span class="stringliteral">&#39;{}{}{}{}{}&#39;</span>.format(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space, start, self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.comma, end,</div>
<div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;                                              self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.space)</div>
<div class="line"><a name="l00323"></a><span class="lineno">  323</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(limit_param)</div>
<div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00325"></a><span class="lineno">  325</span>&#160; </div>
<div class="line"><a name="l00326"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ae00b5cedb3a357a4446d95a2f1372a11">  326</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ae00b5cedb3a357a4446d95a2f1372a11">desc</a>(self):</div>
<div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;<span class="stringliteral">        倒叙</span></div>
<div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).desc()</span></div>
<div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).desc().end()</span></div>
<div class="line"><a name="l00332"></a><span class="lineno">  332</span>&#160;<span class="stringliteral">            find(&#39;all&#39;).order_by(&#39;param&#39;).desc().limit(10,20)</span></div>
<div class="line"><a name="l00333"></a><span class="lineno">  333</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00334"></a><span class="lineno">  334</span>&#160; </div>
<div class="line"><a name="l00335"></a><span class="lineno">  335</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.order_by_str <span class="keywordflow">not</span> <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>:</div>
<div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;            ALog.log_error(</div>
<div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160;                <span class="stringliteral">&#39;There is no `order by` field before calling `desc` field,You have an error in your SQL syntax&#39;</span>,</div>
<div class="line"><a name="l00338"></a><span class="lineno">  338</span>&#160;                AttributeError, LogObject=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.log_obj, raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00339"></a><span class="lineno">  339</span>&#160; </div>
<div class="line"><a name="l00340"></a><span class="lineno">  340</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.desc_str)</div>
<div class="line"><a name="l00341"></a><span class="lineno">  341</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00342"></a><span class="lineno">  342</span>&#160; </div>
<div class="line"><a name="l00343"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1106b1c0a3cd65b792cc563f93c2616a">  343</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1106b1c0a3cd65b792cc563f93c2616a">set</a>(self, **kwargs):</div>
<div class="line"><a name="l00344"></a><span class="lineno">  344</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00345"></a><span class="lineno">  345</span>&#160;<span class="stringliteral">        设置</span></div>
<div class="line"><a name="l00346"></a><span class="lineno">  346</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00347"></a><span class="lineno">  347</span>&#160;<span class="stringliteral">            update(&#39;table&#39;).set(&#39;param&#39;,&#39;value&#39;).end()</span></div>
<div class="line"><a name="l00348"></a><span class="lineno">  348</span>&#160;<span class="stringliteral">            update(&#39;table&#39;).set(&#39;param1&#39;,&#39;value1&#39;).where(&#39;param2=value2&#39;).end()</span></div>
<div class="line"><a name="l00349"></a><span class="lineno">  349</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00350"></a><span class="lineno">  350</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.set_str)</div>
<div class="line"><a name="l00351"></a><span class="lineno">  351</span>&#160;        _size = len(kwargs.keys())</div>
<div class="line"><a name="l00352"></a><span class="lineno">  352</span>&#160;        <span class="keywordflow">for</span> key, value <span class="keywordflow">in</span> kwargs.items():</div>
<div class="line"><a name="l00353"></a><span class="lineno">  353</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(<span class="stringliteral">&#39;{}{}{}{}%s&#39;</span>.format(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.left_subscript,</div>
<div class="line"><a name="l00354"></a><span class="lineno">  354</span>&#160;                                                 key,</div>
<div class="line"><a name="l00355"></a><span class="lineno">  355</span>&#160;                                                 self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.right_subscript,</div>
<div class="line"><a name="l00356"></a><span class="lineno">  356</span>&#160;                                                 self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.eq))</div>
<div class="line"><a name="l00357"></a><span class="lineno">  357</span>&#160;            <span class="comment"># set是加逗号不是and</span></div>
<div class="line"><a name="l00358"></a><span class="lineno">  358</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.comma)</div>
<div class="line"><a name="l00359"></a><span class="lineno">  359</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">params</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(value)</div>
<div class="line"><a name="l00360"></a><span class="lineno">  360</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aa02ed1b6ea243140a96615bce48b9c62">rep_sym</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.comma)</div>
<div class="line"><a name="l00361"></a><span class="lineno">  361</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00362"></a><span class="lineno">  362</span>&#160; </div>
<div class="line"><a name="l00363"></a><span class="lineno">  363</span>&#160;    <span class="comment"># ------------------------预设符--------------------------</span></div>
<div class="line"><a name="l00364"></a><span class="lineno">  364</span>&#160; </div>
<div class="line"><a name="l00365"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad7fcf0545d4e3584f96a074f798f5fa0">  365</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad7fcf0545d4e3584f96a074f798f5fa0">ander</a>(self):</div>
<div class="line"><a name="l00366"></a><span class="lineno">  366</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00367"></a><span class="lineno">  367</span>&#160;<span class="stringliteral">        和</span></div>
<div class="line"><a name="l00368"></a><span class="lineno">  368</span>&#160;<span class="stringliteral">        example:</span></div>
<div class="line"><a name="l00369"></a><span class="lineno">  369</span>&#160;<span class="stringliteral">            update(&#39;table&#39;).set(&#39;param1&#39;,&#39;value1&#39;).and().set(&#39;param2&#39;,&#39;value2&#39;)</span></div>
<div class="line"><a name="l00370"></a><span class="lineno">  370</span>&#160;<span class="stringliteral">            update(&#39;table&#39;).set(&#39;param1&#39;,&#39;value1&#39;).and().set(&#39;param2&#39;,&#39;value2&#39;).end()</span></div>
<div class="line"><a name="l00371"></a><span class="lineno">  371</span>&#160;<span class="stringliteral">            update(&#39;table&#39;).set(&#39;param1&#39;,&#39;value1&#39;).and().set(&#39;param2&#39;,&#39;value2&#39;).where(&#39;param3=value3&#39;).end()</span></div>
<div class="line"><a name="l00372"></a><span class="lineno">  372</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00373"></a><span class="lineno">  373</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.ander_str)</div>
<div class="line"><a name="l00374"></a><span class="lineno">  374</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00375"></a><span class="lineno">  375</span>&#160; </div>
<div class="line"><a name="l00376"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a8cc4f4e52e50fb12850703719404ecb9">  376</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a8cc4f4e52e50fb12850703719404ecb9">run</a>(self, need_sql=False, serializer=True) -&gt; QuerySet:</div>
<div class="line"><a name="l00377"></a><span class="lineno">  377</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00378"></a><span class="lineno">  378</span>&#160;<span class="stringliteral">        最终执行任务</span></div>
<div class="line"><a name="l00379"></a><span class="lineno">  379</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00380"></a><span class="lineno">  380</span>&#160;        sql = <span class="stringliteral">&#39;&#39;</span></div>
<div class="line"><a name="l00381"></a><span class="lineno">  381</span>&#160;        conf = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.get_dict()</div>
<div class="line"><a name="l00382"></a><span class="lineno">  382</span>&#160;        print_sql = <span class="stringliteral">&#39;print_sql&#39;</span> <span class="keywordflow">in</span> conf.keys() <span class="keywordflow">and</span> conf[<span class="stringliteral">&#39;print_sql&#39;</span>] <span class="keywordflow">is</span> <span class="keyword">True</span></div>
<div class="line"><a name="l00383"></a><span class="lineno">  383</span>&#160;        last_id = <span class="stringliteral">&#39;last_id&#39;</span> <span class="keywordflow">in</span> conf.keys() <span class="keywordflow">and</span> conf[<span class="stringliteral">&#39;last_id&#39;</span>] <span class="keywordflow">is</span> <span class="keyword">True</span></div>
<div class="line"><a name="l00384"></a><span class="lineno">  384</span>&#160;        sql += <span class="stringliteral">&#39;&#39;</span>.join(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>)</div>
<div class="line"><a name="l00385"></a><span class="lineno">  385</span>&#160;        <span class="keywordflow">if</span> need_sql:</div>
<div class="line"><a name="l00386"></a><span class="lineno">  386</span>&#160;            <span class="keywordflow">return</span> sql</div>
<div class="line"><a name="l00387"></a><span class="lineno">  387</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a3cb975fab2652904b97d5273879fdd24">exmode</a> == AOrm.Mode.FIND:</div>
<div class="line"><a name="l00388"></a><span class="lineno">  388</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a> = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.db_util.select(</div>
<div class="line"><a name="l00389"></a><span class="lineno">  389</span>&#160;                sql=sql,</div>
<div class="line"><a name="l00390"></a><span class="lineno">  390</span>&#160;                params=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">params</a>,</div>
<div class="line"><a name="l00391"></a><span class="lineno">  391</span>&#160;                print_sql=print_sql,</div>
<div class="line"><a name="l00392"></a><span class="lineno">  392</span>&#160;                last_id=last_id,</div>
<div class="line"><a name="l00393"></a><span class="lineno">  393</span>&#160;                **self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.__dict__</div>
<div class="line"><a name="l00394"></a><span class="lineno">  394</span>&#160;            )</div>
<div class="line"><a name="l00395"></a><span class="lineno">  395</span>&#160;            _result_objs = []</div>
<div class="line"><a name="l00396"></a><span class="lineno">  396</span>&#160;            <span class="keywordflow">for</span> i <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a>:</div>
<div class="line"><a name="l00397"></a><span class="lineno">  397</span>&#160;                _obj = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">ParseUtil</a>.parse_obj(</div>
<div class="line"><a name="l00398"></a><span class="lineno">  398</span>&#160;                    data=i, instance=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.instance)</div>
<div class="line"><a name="l00399"></a><span class="lineno">  399</span>&#160;                _result_objs.append(_obj)</div>
<div class="line"><a name="l00400"></a><span class="lineno">  400</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a> = _result_objs</div>
<div class="line"><a name="l00401"></a><span class="lineno">  401</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00402"></a><span class="lineno">  402</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a> = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.db_util.update(</div>
<div class="line"><a name="l00403"></a><span class="lineno">  403</span>&#160;                sql=sql,</div>
<div class="line"><a name="l00404"></a><span class="lineno">  404</span>&#160;                params=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">params</a>,</div>
<div class="line"><a name="l00405"></a><span class="lineno">  405</span>&#160;                print_sql=print_sql,</div>
<div class="line"><a name="l00406"></a><span class="lineno">  406</span>&#160;                last_id=last_id</div>
<div class="line"><a name="l00407"></a><span class="lineno">  407</span>&#160;            )</div>
<div class="line"><a name="l00408"></a><span class="lineno">  408</span>&#160;        <span class="comment"># 清空资源，为下一次使用做准备</span></div>
<div class="line"><a name="l00409"></a><span class="lineno">  409</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.clear()</div>
<div class="line"><a name="l00410"></a><span class="lineno">  410</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">params</a>.clear()</div>
<div class="line"><a name="l00411"></a><span class="lineno">  411</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a20a40eeded43e60f93bf7904d81f9c24">first_data</a>:</div>
<div class="line"><a name="l00412"></a><span class="lineno">  412</span>&#160;            <span class="keywordflow">if</span> (isinstance(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a>, list) <span class="keywordflow">or</span> isinstance(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a>, tuple)) <span class="keywordflow">and</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a> <span class="keywordflow">and</span> len(</div>
<div class="line"><a name="l00413"></a><span class="lineno">  413</span>&#160;                    self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a>) &gt; 0:</div>
<div class="line"><a name="l00414"></a><span class="lineno">  414</span>&#160;                <span class="keywordflow">if</span> <span class="keywordflow">not</span> serializer:</div>
<div class="line"><a name="l00415"></a><span class="lineno">  415</span>&#160;                    <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a>[0]</div>
<div class="line"><a name="l00416"></a><span class="lineno">  416</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.result = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7716439abad4da73688382cf3b3ca1e9">serializer</a>(instance=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.instance,</div>
<div class="line"><a name="l00417"></a><span class="lineno">  417</span>&#160;                                                         base_data=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a>).<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a64abf4fbb49d50cc108f0c744594f042">first</a>()</div>
<div class="line"><a name="l00418"></a><span class="lineno">  418</span>&#160;                <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.result</div>
<div class="line"><a name="l00419"></a><span class="lineno">  419</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00420"></a><span class="lineno">  420</span>&#160;                self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.result = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7716439abad4da73688382cf3b3ca1e9">serializer</a>()</div>
<div class="line"><a name="l00421"></a><span class="lineno">  421</span>&#160;                <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.result</div>
<div class="line"><a name="l00422"></a><span class="lineno">  422</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00423"></a><span class="lineno">  423</span>&#160;            <span class="keywordflow">if</span> <span class="keywordflow">not</span> serializer:</div>
<div class="line"><a name="l00424"></a><span class="lineno">  424</span>&#160;                <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a></div>
<div class="line"><a name="l00425"></a><span class="lineno">  425</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.result = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7716439abad4da73688382cf3b3ca1e9">serializer</a>(</div>
<div class="line"><a name="l00426"></a><span class="lineno">  426</span>&#160;                instance=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.instance, base_data=self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">_result</a>)</div>
<div class="line"><a name="l00427"></a><span class="lineno">  427</span>&#160;            <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.result</div>
<div class="line"><a name="l00428"></a><span class="lineno">  428</span>&#160; </div>
<div class="line"><a name="l00429"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a562a70aa148e2a09e5075a22fa8d4328">  429</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a562a70aa148e2a09e5075a22fa8d4328">con_from</a>(self):</div>
<div class="line"><a name="l00430"></a><span class="lineno">  430</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00431"></a><span class="lineno">  431</span>&#160;<span class="stringliteral">        如果没有被from包含,则在末尾加上from __table_name__关键字</span></div>
<div class="line"><a name="l00432"></a><span class="lineno">  432</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00433"></a><span class="lineno">  433</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.from_str <span class="keywordflow">not</span> <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>:</div>
<div class="line"><a name="l00434"></a><span class="lineno">  434</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.from_str)</div>
<div class="line"><a name="l00435"></a><span class="lineno">  435</span>&#160;            <span class="comment"># 然后加上表名</span></div>
<div class="line"><a name="l00436"></a><span class="lineno">  436</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.left_subscript)</div>
<div class="line"><a name="l00437"></a><span class="lineno">  437</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7ab8434322f16348ffeab31e8d49a24c">__table_name__</a>)</div>
<div class="line"><a name="l00438"></a><span class="lineno">  438</span>&#160;            self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.right_subscript)</div>
<div class="line"><a name="l00439"></a><span class="lineno">  439</span>&#160; </div>
<div class="line"><a name="l00440"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">  440</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self, app_sql):</div>
<div class="line"><a name="l00441"></a><span class="lineno">  441</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00442"></a><span class="lineno">  442</span>&#160;<span class="stringliteral">        末尾追加一些sql</span></div>
<div class="line"><a name="l00443"></a><span class="lineno">  443</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00444"></a><span class="lineno">  444</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(app_sql)</div>
<div class="line"><a name="l00445"></a><span class="lineno">  445</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00446"></a><span class="lineno">  446</span>&#160; </div>
<div class="line"><a name="l00447"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aa02ed1b6ea243140a96615bce48b9c62">  447</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aa02ed1b6ea243140a96615bce48b9c62">rep_sym</a>(self, sym=&#39;,&#39;, rep=&#39;&#39;):</div>
<div class="line"><a name="l00448"></a><span class="lineno">  448</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00449"></a><span class="lineno">  449</span>&#160;<span class="stringliteral">        将最后一个参数包含的指定字符替换为指定字符</span></div>
<div class="line"><a name="l00450"></a><span class="lineno">  450</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00451"></a><span class="lineno">  451</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>[len(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>) -</div>
<div class="line"><a name="l00452"></a><span class="lineno">  452</span>&#160;                  1] = str(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>[len(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>) - 1]).replace(sym, rep)</div>
<div class="line"><a name="l00453"></a><span class="lineno">  453</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00454"></a><span class="lineno">  454</span>&#160; </div>
<div class="line"><a name="l00455"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2134504d320f5a399f8b2341515093b6">  455</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2134504d320f5a399f8b2341515093b6">end</a>(self, **kwargs):</div>
<div class="line"><a name="l00456"></a><span class="lineno">  456</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a8cc4f4e52e50fb12850703719404ecb9">run</a>(**kwargs)</div>
<div class="line"><a name="l00457"></a><span class="lineno">  457</span>&#160; </div>
<div class="line"><a name="l00458"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab602be018bd859662317ba2707025923">  458</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab602be018bd859662317ba2707025923">__rshift__</a>(self, other):</div>
<div class="line"><a name="l00459"></a><span class="lineno">  459</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00460"></a><span class="lineno">  460</span>&#160;<span class="stringliteral">        将左边orm迁移至右边</span></div>
<div class="line"><a name="l00461"></a><span class="lineno">  461</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00462"></a><span class="lineno">  462</span>&#160;        new_args = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.copy()</div>
<div class="line"><a name="l00463"></a><span class="lineno">  463</span>&#160;        new_args.append(<span class="stringliteral">&#39; ) &#39;</span>)</div>
<div class="line"><a name="l00464"></a><span class="lineno">  464</span>&#160;        other.args.append(<span class="stringliteral">&#39; ( &#39;</span>)</div>
<div class="line"><a name="l00465"></a><span class="lineno">  465</span>&#160;        other.args += new_args</div>
<div class="line"><a name="l00466"></a><span class="lineno">  466</span>&#160;        <span class="keywordflow">return</span> other</div>
<div class="line"><a name="l00467"></a><span class="lineno">  467</span>&#160; </div>
<div class="line"><a name="l00468"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a85669a2ee73c664f7dbe144bc966a9b6">  468</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a85669a2ee73c664f7dbe144bc966a9b6">__lshift__</a>(self, other):</div>
<div class="line"><a name="l00469"></a><span class="lineno">  469</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00470"></a><span class="lineno">  470</span>&#160;<span class="stringliteral">        将右边迁移至左边</span></div>
<div class="line"><a name="l00471"></a><span class="lineno">  471</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00472"></a><span class="lineno">  472</span>&#160;        new_args = other.args.copy()</div>
<div class="line"><a name="l00473"></a><span class="lineno">  473</span>&#160;        new_args.append(<span class="stringliteral">&#39; ) &#39;</span>)</div>
<div class="line"><a name="l00474"></a><span class="lineno">  474</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(<span class="stringliteral">&#39; ( &#39;</span>)</div>
<div class="line"><a name="l00475"></a><span class="lineno">  475</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a> = self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a> + new_args</div>
<div class="line"><a name="l00476"></a><span class="lineno">  476</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00477"></a><span class="lineno">  477</span>&#160; </div>
<div class="line"><a name="l00478"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1fe473644dd09cb7dc134ffb6bf2fc4b">  478</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1fe473644dd09cb7dc134ffb6bf2fc4b">alias</a>(self, name):</div>
<div class="line"><a name="l00479"></a><span class="lineno">  479</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00480"></a><span class="lineno">  480</span>&#160;<span class="stringliteral">        设置别名</span></div>
<div class="line"><a name="l00481"></a><span class="lineno">  481</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00482"></a><span class="lineno">  482</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(<span class="stringliteral">&#39; AS &#39;</span>)</div>
<div class="line"><a name="l00483"></a><span class="lineno">  483</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(name)</div>
<div class="line"><a name="l00484"></a><span class="lineno">  484</span>&#160;        <span class="keywordflow">return</span> self</div>
<div class="line"><a name="l00485"></a><span class="lineno">  485</span>&#160; </div>
<div class="line"><a name="l00486"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ae232848f65fd4308a2bf37ca9ae8e2fb">  486</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ae232848f65fd4308a2bf37ca9ae8e2fb">left_join</a>(self, sql_orm, name):</div>
<div class="line"><a name="l00487"></a><span class="lineno">  487</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00488"></a><span class="lineno">  488</span>&#160;<span class="stringliteral">        left join</span></div>
<div class="line"><a name="l00489"></a><span class="lineno">  489</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00490"></a><span class="lineno">  490</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">sqlFields</a>.left_join_str)</div>
<div class="line"><a name="l00491"></a><span class="lineno">  491</span>&#160;        self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">append</a>(sql_orm.__table_name__)</div>
<div class="line"><a name="l00492"></a><span class="lineno">  492</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1fe473644dd09cb7dc134ffb6bf2fc4b">alias</a>(name)</div>
<div class="line"><a name="l00493"></a><span class="lineno">  493</span>&#160; </div>
<div class="line"><a name="l00494"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a35a72dd9dc824872d147ecd66d5d3ce5">  494</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a35a72dd9dc824872d147ecd66d5d3ce5">__str__</a>(self):</div>
<div class="line"><a name="l00495"></a><span class="lineno">  495</span>&#160;        sql = <span class="stringliteral">&#39;&#39;</span>.join(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">args</a>)</div>
<div class="line"><a name="l00496"></a><span class="lineno">  496</span>&#160;        <span class="keywordflow">return</span> sql</div>
<div class="line"><a name="l00497"></a><span class="lineno">  497</span>&#160; </div>
<div class="line"><a name="l00498"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a85909eb992d2e8236da0fc8676572ff3">  498</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a85909eb992d2e8236da0fc8676572ff3">check</a>(self):</div>
<div class="line"><a name="l00499"></a><span class="lineno">  499</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;sudo apt install containerd</span></div>
<div class="line"><a name="l00500"></a><span class="lineno">  500</span>&#160;<span class="stringliteral">        检查表结构与数据库中是否对应</span></div>
<div class="line"><a name="l00501"></a><span class="lineno">  501</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00502"></a><span class="lineno">  502</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.config_obj.opera(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>).<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a85909eb992d2e8236da0fc8676572ff3">check</a>()</div>
<div class="line"><a name="l00503"></a><span class="lineno">  503</span>&#160; </div>
<div class="line"><a name="l00504"></a><span class="lineno"><a class="line" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1f5c7190aee672a77dae6c11b262a1e6">  504</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1f5c7190aee672a77dae6c11b262a1e6">create</a>(self):</div>
<div class="line"><a name="l00505"></a><span class="lineno">  505</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>.config_obj.opera(self.<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">repository</a>).<a class="code" href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1f5c7190aee672a77dae6c11b262a1e6">create</a>()</div>
</div><!-- fragment --></div><!-- contents -->
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a7716439abad4da73688382cf3b3ca1e9"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7716439abad4da73688382cf3b3ca1e9">aestate.work.orm.AOrm.serializer</a></div><div class="ttdeci">serializer</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00097">orm.py:97</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ae232848f65fd4308a2bf37ca9ae8e2fb"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ae232848f65fd4308a2bf37ca9ae8e2fb">aestate.work.orm.AOrm.left_join</a></div><div class="ttdeci">def left_join(self, sql_orm, name)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00486">orm.py:486</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a8cc4f4e52e50fb12850703719404ecb9"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a8cc4f4e52e50fb12850703719404ecb9">aestate.work.orm.AOrm.run</a></div><div class="ttdeci">QuerySet run(self, need_sql=False, serializer=True)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00376">orm.py:376</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a1fe473644dd09cb7dc134ffb6bf2fc4b"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1fe473644dd09cb7dc134ffb6bf2fc4b">aestate.work.orm.AOrm.alias</a></div><div class="ttdeci">def alias(self, name)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00478">orm.py:478</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a2c4d974e8913c2a29f0dcdff18a88b85"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2c4d974e8913c2a29f0dcdff18a88b85">aestate.work.orm.AOrm.order_by</a></div><div class="ttdeci">def order_by(self, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00194">orm.py:194</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_base_cover_html_a5ea8415f62dd65c49595a0908378dc5d"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_base_cover.html#a5ea8415f62dd65c49595a0908378dc5d">aestate.work.orm.BaseCover.check</a></div><div class="ttdeci">bool check(self, res, fields)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00025">orm.py:25</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a9fb4513ed4e7ca1470526c7faea7b841"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a9fb4513ed4e7ca1470526c7faea7b841">aestate.work.orm.AOrm.find</a></div><div class="ttdeci">def find(self, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00125">orm.py:125</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a1f5c7190aee672a77dae6c11b262a1e6"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1f5c7190aee672a77dae6c11b262a1e6">aestate.work.orm.AOrm.create</a></div><div class="ttdeci">def create(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00504">orm.py:504</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_af3b713b0da4f77055924801889a8cf05"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#af3b713b0da4f77055924801889a8cf05">aestate.work.orm.AOrm.repository</a></div><div class="ttdeci">repository</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00104">orm.py:104</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_base_cover_html"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_base_cover.html">aestate.work.orm.BaseCover</a></div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00011">orm.py:11</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a7ab8434322f16348ffeab31e8d49a24c"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7ab8434322f16348ffeab31e8d49a24c">aestate.work.orm.AOrm.__table_name__</a></div><div class="ttdeci">__table_name__</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00107">orm.py:107</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a0dbc81a347ac1b5d2593c8e177a30efc"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a0dbc81a347ac1b5d2593c8e177a30efc">aestate.work.orm.AOrm.group_by</a></div><div class="ttdeci">def group_by(self, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00204">orm.py:204</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ad37f44b2337c88899e81367328a44777"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad37f44b2337c88899e81367328a44777">aestate.work.orm.AOrm.by_opera</a></div><div class="ttdeci">def by_opera(self, field, args_list, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00212">orm.py:212</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ab2cbe9f088da506d307540e83e2fa784"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab2cbe9f088da506d307540e83e2fa784">aestate.work.orm.AOrm.where</a></div><div class="ttdeci">def where(self, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00230">orm.py:230</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a35a72dd9dc824872d147ecd66d5d3ce5"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a35a72dd9dc824872d147ecd66d5d3ce5">aestate.work.orm.AOrm.__str__</a></div><div class="ttdeci">def __str__(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00494">orm.py:494</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_1_1_mode_html"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm_1_1_mode.html">aestate.work.orm.AOrm.Mode</a></div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00078">orm.py:78</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a969ef8419a841f35ce747f9b1103f7cc"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a969ef8419a841f35ce747f9b1103f7cc">aestate.work.orm.AOrm.ParseUtil</a></div><div class="ttdeci">ParseUtil</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00096">orm.py:96</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1work_1_1_serialize_html"><div class="ttname"><a href="namespaceaestate_1_1work_1_1_serialize.html">aestate.work.Serialize</a></div><div class="ttdef"><b>Definition:</b> <a href="_serialize_8py_source.html#l00001">Serialize.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ab602be018bd859662317ba2707025923"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab602be018bd859662317ba2707025923">aestate.work.orm.AOrm.__rshift__</a></div><div class="ttdeci">def __rshift__(self, other)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00458">orm.py:458</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a5e33e3ce956bedc483e6e20b84f3e32f"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a5e33e3ce956bedc483e6e20b84f3e32f">aestate.work.orm.AOrm._result</a></div><div class="ttdeci">_result</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00110">orm.py:110</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a2134504d320f5a399f8b2341515093b6"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2134504d320f5a399f8b2341515093b6">aestate.work.orm.AOrm.end</a></div><div class="ttdeci">def end(self, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00455">orm.py:455</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_afa2aeb58d63792b5d3602805e3de60d1"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#afa2aeb58d63792b5d3602805e3de60d1">aestate.work.orm.AOrm.params</a></div><div class="ttdeci">params</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00093">orm.py:93</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ad28cce2cfb2b41fd5ff2b6fa65797cbf"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad28cce2cfb2b41fd5ff2b6fa65797cbf">aestate.work.orm.AOrm.args</a></div><div class="ttdeci">args</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00092">orm.py:92</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a3cb975fab2652904b97d5273879fdd24"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a3cb975fab2652904b97d5273879fdd24">aestate.work.orm.AOrm.exmode</a></div><div class="ttdeci">exmode</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00091">orm.py:91</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_aa02ed1b6ea243140a96615bce48b9c62"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aa02ed1b6ea243140a96615bce48b9c62">aestate.work.orm.AOrm.rep_sym</a></div><div class="ttdeci">def rep_sym(self, sym=',', rep='')</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00447">orm.py:447</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ad7fcf0545d4e3584f96a074f798f5fa0"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ad7fcf0545d4e3584f96a074f798f5fa0">aestate.work.orm.AOrm.ander</a></div><div class="ttdeci">def ander(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00365">orm.py:365</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a13f5cec1d673aeaf79a374f966dd582d"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a13f5cec1d673aeaf79a374f966dd582d">aestate.work.orm.AOrm.__init__</a></div><div class="ttdeci">def __init__(self, repository)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00082">orm.py:82</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_aecea12850afc3b40f8847c4b308978cb"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aecea12850afc3b40f8847c4b308978cb">aestate.work.orm.AOrm.filter</a></div><div class="ttdeci">def filter(self, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00227">orm.py:227</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a48d6b59a96a8ac8e9e19b6a5f4d80bf0"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a48d6b59a96a8ac8e9e19b6a5f4d80bf0">aestate.work.orm.AOrm.on</a></div><div class="ttdeci">def on(self, from_where, to_where, symbol='=')</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00295">orm.py:295</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1util_1_1_log_html"><div class="ttname"><a href="namespaceaestate_1_1util_1_1_log.html">aestate.util.Log</a></div><div class="ttdef"><b>Definition:</b> <a href="_log_8py_source.html#l00001">Log.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ae00b5cedb3a357a4446d95a2f1372a11"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ae00b5cedb3a357a4446d95a2f1372a11">aestate.work.orm.AOrm.desc</a></div><div class="ttdeci">def desc(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00326">orm.py:326</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1exception_html"><div class="ttname"><a href="namespaceaestate_1_1exception.html">aestate.exception</a></div><div class="ttdef"><b>Definition:</b> <a href="exception_2____init_____8py_source.html#l00001">__init__.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_base_cover_html_ac402c2f8b3349e9150aad473020136e3"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_base_cover.html#ac402c2f8b3349e9150aad473020136e3">aestate.work.orm.BaseCover.res</a></div><div class="ttdeci">dict res(self, tb_name, db_name, extool)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00042">orm.py:42</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a562a70aa148e2a09e5075a22fa8d4328"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a562a70aa148e2a09e5075a22fa8d4328">aestate.work.orm.AOrm.con_from</a></div><div class="ttdeci">def con_from(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00429">orm.py:429</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a1106b1c0a3cd65b792cc563f93c2616a"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a1106b1c0a3cd65b792cc563f93c2616a">aestate.work.orm.AOrm.set</a></div><div class="ttdeci">def set(self, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00343">orm.py:343</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_ab69882819e39ac65ce9bef53e01936d7"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#ab69882819e39ac65ce9bef53e01936d7">aestate.work.orm.AOrm.append</a></div><div class="ttdeci">def append(self, app_sql)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00440">orm.py:440</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a20a40eeded43e60f93bf7904d81f9c24"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a20a40eeded43e60f93bf7904d81f9c24">aestate.work.orm.AOrm.first_data</a></div><div class="ttdeci">first_data</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00109">orm.py:109</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a2433aa49e6cbb51e5303bd1fb2af9a56"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a2433aa49e6cbb51e5303bd1fb2af9a56">aestate.work.orm.AOrm.sqlFields</a></div><div class="ttdeci">sqlFields</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00094">orm.py:94</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_base_cover_html_a670815366267017770d6db1ada6ac5b2"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_base_cover.html#a670815366267017770d6db1ada6ac5b2">aestate.work.orm.BaseCover.table_visual</a></div><div class="ttdeci">PrettyTable table_visual(self, list title, List[dict] val)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00013">orm.py:13</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a64abf4fbb49d50cc108f0c744594f042"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a64abf4fbb49d50cc108f0c744594f042">aestate.work.orm.AOrm.first</a></div><div class="ttdeci">def first(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00117">orm.py:117</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_base_cover_html_af6f5380092b58753896534d43e9a7c77"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_base_cover.html#af6f5380092b58753896534d43e9a7c77">aestate.work.orm.BaseCover.deal</a></div><div class="ttdeci">def deal(self, res, fields)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00036">orm.py:36</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_aba9039f7e0b2d296188f876e9a7b698d"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#aba9039f7e0b2d296188f876e9a7b698d">aestate.work.orm.AOrm.top</a></div><div class="ttdeci">def top(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00112">orm.py:112</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html">aestate.work.orm.AOrm</a></div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00067">orm.py:67</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a85669a2ee73c664f7dbe144bc966a9b6"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a85669a2ee73c664f7dbe144bc966a9b6">aestate.work.orm.AOrm.__lshift__</a></div><div class="ttdeci">def __lshift__(self, other)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00468">orm.py:468</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a85909eb992d2e8236da0fc8676572ff3"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a85909eb992d2e8236da0fc8676572ff3">aestate.work.orm.AOrm.check</a></div><div class="ttdeci">def check(self)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00498">orm.py:498</a></div></div>
<div class="ttc" id="aclassaestate_1_1work_1_1orm_1_1_a_orm_html_a7234a2fefab09fac24d58a77b2001bb2"><div class="ttname"><a href="classaestate_1_1work_1_1orm_1_1_a_orm.html#a7234a2fefab09fac24d58a77b2001bb2">aestate.work.orm.AOrm.limit</a></div><div class="ttdeci">def limit(self, start=0, end=None)</div><div class="ttdef"><b>Definition:</b> <a href="orm_8py_source.html#l00306">orm.py:306</a></div></div>
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.17
</small></address>
</body>
</html>
